#merge、concat 练习
import pandas as pd

df1 = pd.read_excel('D:/ITAudit/pandas_excel/Student_Score.xlsx',sheet_name='Students')
df2 = pd.read_excel('D:/ITAudit/pandas_excel/Student_Score.xlsx',sheet_name='Scores')
table1 = df1.merge(df2,how='left')
# print(table1)
table2 = pd.concat([df1,df2],keys=['表1','表2'])
print(table2)
table3= pd.concat([df1,df2],axis=1,join='inner')
print(table3)